UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HmCYlCSxwOdTXZUIwn0TEpsmwf5eNsV+kxwupBw3xSg='
WHERE
key_id = '556a0c92400563e3c5cc4cff535995d532a26f134cce9b5fbe9e58176142e46b'
AND (
token = 'HmCYlCSxwOdTXZUIwn0TEpsmwf5eNsV+kxwupBw3xSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)