UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcU7c/BoDiNmwxL87Qeu8KRBb+rK1oZmM3/c7hxJlOM='
WHERE
key_id = 'd5d03782c5def7e839157dac85464de3a0083f0fc54ee7798fc4b3c966c92559'
AND (
token = 'bcU7c/BoDiNmwxL87Qeu8KRBb+rK1oZmM3/c7hxJlOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)