UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dX+Tlj2v5Eja4fGB2WBQBGqwopZchYtYmjgurWyiF2w='
WHERE
key_id = 'dc78c877a0347c3d92b1a627a70fb6d39d4dfafa0ef3f1d59f5f3712b669019a'
AND (
token = 'dX+Tlj2v5Eja4fGB2WBQBGqwopZchYtYmjgurWyiF2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)