UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZaSmr3dF19NVcisk89LXMJZtd4ReCD3tqbiaFgStXK4='
WHERE
key_id = '67d10c8a4fc5996742ab04979877edad783e2eae92c3adcbe9a666f4b7111907'
AND (
token = 'ZaSmr3dF19NVcisk89LXMJZtd4ReCD3tqbiaFgStXK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)