UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TECTPrp8qGJV8TsWId/WSDI5LWni6e1adfviw2dXVqs='
WHERE
key_id = 'a5c740b3e31ff920ad9710940b5e1f0898f1c5d0911c5e0e83fbcf7e0cfcc8d5'
AND (
token = 'TECTPrp8qGJV8TsWId/WSDI5LWni6e1adfviw2dXVqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)