UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9apF8tZ6n5xGOjF3nq3GC19x6wILhC9VA5sDBLaEENI='
WHERE
key_id = 'b6c6f79135727c8960519d9ad5db3763df88b39c99916d5b4c40934ef64570c1'
AND (
token = '9apF8tZ6n5xGOjF3nq3GC19x6wILhC9VA5sDBLaEENI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)