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