UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTheTvIdhxhKG067fQggv59nbadas4nIWD82dOSsYdI='
WHERE
key_id = '157619b2b1862e5811e078c660e593f20ec72f089cc824a413078c08bb6e92d3'
AND (
token = 'bTheTvIdhxhKG067fQggv59nbadas4nIWD82dOSsYdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)