UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1i+0sO7PIjrDYHM1LIlf+VEemF6lOnbyIsLPKBLWx0='
WHERE
key_id = '1adf4c075a19fdc689ae08cdc2b7e2b553f463d5a71a7a202308a6232b6762f1'
AND (
token = 'X1i+0sO7PIjrDYHM1LIlf+VEemF6lOnbyIsLPKBLWx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)