UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+wq1apx1FB61e5RUHLEFoo8LA5wGp9S/bz/qsrNsH4='
WHERE
key_id = 'e18dc3ce56ea5d5a65d5442993394b99e7b60b08780aa53cefbad3ee617c6d4a'
AND (
token = 'Z+wq1apx1FB61e5RUHLEFoo8LA5wGp9S/bz/qsrNsH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)