UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A3hKoerrvn2xAnufEpz9cuEhqEK9AfBlZo1v+Iv5mLU='
WHERE
key_id = '0a6ca7d75e515484f56f832245a9c2c9c0580c7308c5841fc7bce0378fe620c5'
AND (
token = 'A3hKoerrvn2xAnufEpz9cuEhqEK9AfBlZo1v+Iv5mLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)