UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VVYvLqERdCnqqpOwjNamYoYTfV5cdXiM6KgsESDz/LU='
WHERE
key_id = 'c8dd7c7e40efab1c6aee0161815ffc1596f364c91c1734ec307544fd56420086'
AND (
token = 'VVYvLqERdCnqqpOwjNamYoYTfV5cdXiM6KgsESDz/LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)