UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgBISvnRpvGSKau2ap919Lh2rns/mb30CdMWta3+KkI='
WHERE
key_id = '0d1c7e0717a8ec1cebd4c19d8bfda3ad71fa113ab625ac0c80cb2f1940e5e59f'
AND (
token = 'sgBISvnRpvGSKau2ap919Lh2rns/mb30CdMWta3+KkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)