UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxNHlZfdvM48liV9CheicMw6yQzmHb8y8OuFij8Wg2o='
WHERE
key_id = 'fcfb77935f016d9df9a7d820afaa5f95b28fe9ebb40c995e2ab33d9fe3bd220d'
AND (
token = 'nxNHlZfdvM48liV9CheicMw6yQzmHb8y8OuFij8Wg2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)