UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXmQj6tZ491q7DO8T70SSDsmWToQV1xPqpcswNWrXXg='
WHERE
key_id = 'ac0ee17827547470062fc9a70ee9eee05a6e6f70c8531624c2366ade7f4e8ded'
AND (
token = 'mXmQj6tZ491q7DO8T70SSDsmWToQV1xPqpcswNWrXXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)