UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SjnMOvna4BIjVddnGqe8GHmpiYNR/GKsHpFQU71AvG4='
WHERE
key_id = '6c92520d7dbe07c50f25beb85484ea8862abeb27e9157ccc0f8f76ee4d47546a'
AND (
token = 'SjnMOvna4BIjVddnGqe8GHmpiYNR/GKsHpFQU71AvG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)