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