UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZqozFMIGf5aL21oKBnWiGHFz4ODVA5pBZT2QlqIRRs='
WHERE
key_id = '1a7477b4911921730f59de019d3c6c48a99fa54cd8a9556765553ffca2e4357e'
AND (
token = '2ZqozFMIGf5aL21oKBnWiGHFz4ODVA5pBZT2QlqIRRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)