UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3zqRBbaSIF1wYv4++ubdZgd73RCtuHcyY8jD+CdtyTk='
WHERE
key_id = 'e204bbc6b92868c2473c8950520bd10a62dd29d5c636d1095cf282e92a0f4192'
AND (
token = '3zqRBbaSIF1wYv4++ubdZgd73RCtuHcyY8jD+CdtyTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)