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