UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0r+V+Fvqy4WzujRSwX4tfI7c1etugeIiujDjIaq9KY='
WHERE
key_id = '312476cf6a8c69188abb687c036226fe423a2c47a2c6e470ea841a625c970150'
AND (
token = 'X0r+V+Fvqy4WzujRSwX4tfI7c1etugeIiujDjIaq9KY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)