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