UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nGBdWk+RWLzihplDmE2yzNxKop4Oh6Sm6i3Es8e3YZY='
WHERE
key_id = 'da3ec019b841b31c8950f2ff92bf8b62ed24388e90fb9ff1525c68108ab1828b'
AND (
token = 'nGBdWk+RWLzihplDmE2yzNxKop4Oh6Sm6i3Es8e3YZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)