UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gt1gavRGjj/wbV6m7RFkV/0VnetjaTYxMTi5HMrJbQ='
WHERE
key_id = '9d54b7fa392606f8f6d0e2af94aa3d2b7dd81ac0cbb6ffd5c6f8dd7f0c6f867e'
AND (
token = '6gt1gavRGjj/wbV6m7RFkV/0VnetjaTYxMTi5HMrJbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)