UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q41zL6wfMzrn3Lxmco2IAVpgDc55ZyN31zfc9BHuV90='
WHERE
key_id = '2b2e27e3371a398de80cf5e1a7e01ffca4177fc033a1f713ed078d3b6a264ceb'
AND (
token = 'q41zL6wfMzrn3Lxmco2IAVpgDc55ZyN31zfc9BHuV90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)