UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5yf30VbsZNbi6SdOKHaf5ztjnuacCXIiMUayMQN6sa8='
WHERE
key_id = '339e1f9ca52100c9de02f7b7e09895dee78fd64a035d9d8c0403d031389a5e67'
AND (
token = '5yf30VbsZNbi6SdOKHaf5ztjnuacCXIiMUayMQN6sa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)