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