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