UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMgo2om7L4fAFV0d5m1pjjlRsb1skN0w63JhGCzepVY='
WHERE
key_id = '8d7a3a9e68ca6006990cc7494eadca618e3a3bdffed722b6bc4d2aca27663272'
AND (
token = 'BMgo2om7L4fAFV0d5m1pjjlRsb1skN0w63JhGCzepVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)